Nick Korna
Nick Korna
Reactions
-
Re: COUNTIF functions returning 0
Hi @roxxtheboxx, Amend your formula slightly: =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, VALUE(@cell)=1, {Dump: OPEN AND CLOSED REQS Range 2}, "Open") This should fix the issue for you…1 · -
Re: Countifs to Consider More than one drop down in one range of data
Hi @Brianne, You can get round this by introducing some OR & CONTAINS: =COUNTIFS({Site Wide SOC's 2024 Range 2}:{Site Wide SOC's 2024 Range 2}, OR(CONTAINS("Plant Maintenance", @cell), …1 · -
Re: February 29th Automations?
Hi @Jack Parry, It should do - you can see in the calendar for when to start an automation that Feb this year has 29 days but next year only it only has 28.1 · -
Re: What is Unparseable about this formula?
Hi @bhsiao_regcorp, You need some @cell references in there (assuming your cross sheet ranges are OK): =SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, @cell >= [Week Start]…1 · -
Re: Symbol, Checkbox, Percent Complete formulas
Hi @Eddie Endurium LLC Depending on how your sheets are arranged, you can do this with either a VLOOKUP or an INDEX/COLLECT and some cross sheet references. For example, to pull the symbol from Sheet…1 ·
